<TemplatesExport family="Live Templates">
  <Template uid="1f9e44d7-2697-49ae-a246-dcd3491be7c8" text="var $cmd$ = MockRepository.GenerateMock&lt;IDbCommand&gt;();&#xD;&#xA;$cn$.Expect(x =&gt; x.CreateCommand()).Return($cmd$);&#xD;&#xA;$cmd$.Expect(x =&gt; x.CommandText).PropertyBehavior();&#xD;&#xA;$cmd$.Expect(x =&gt; x.CommandType).PropertyBehavior();&#xD;&#xA;$END$" shortcut="ccmd" description="Creates a mock command" reformat="true" shortenQualifiedReferences="true">
    <Categories />
    <Variables>
      <Variable name="cmd" expression="" initialRange="0" />
      <Variable name="cn" expression="" initialRange="0" />
    </Variables>
    <CustomProperties />
  </Template>
  <Template uid="dea95421-b9d9-4241-8aaf-646a762fd55b" text="var $cmd$ = $cn$.CreateCommand();&#xD;&#xA;$cmd$.CommandType = CommandType.StoredProcedure;&#xD;&#xA;$cmd$.CommandText = &quot;$CommandText$&quot;;&#xD;&#xA;$END$" shortcut="cmd" description="Creates a IDbCommand" reformat="true" shortenQualifiedReferences="true">
    <Categories />
    <Variables>
      <Variable name="cmd" expression="" initialRange="0" />
      <Variable name="cn" expression="" initialRange="0" />
      <Variable name="CommandText" expression="" initialRange="0" />
    </Variables>
    <CustomProperties />
  </Template>
  <Template uid="bf9d8487-0dac-4174-ad8c-45269037c569" text="var $OutputParameter$ = $cmd$.CreateParameter();&#xD;&#xA;$OutputParameter$.ParameterName = &quot;@$parameterName$&quot;;&#xD;&#xA;$OutputParameter$.DbType = DbType.$DbType$;&#xD;&#xA;$OutputParameter$.Direction = ParameterDirection.Output;&#xD;&#xA;$cmd$.Parameters.Add($OutputParameter$);" shortcut="op" description="Creates an output parameter" reformat="true" shortenQualifiedReferences="true">
    <Categories />
    <Variables>
      <Variable name="OutputParameter" expression="" initialRange="0" />
      <Variable name="cmd" expression="" initialRange="0" />
      <Variable name="DbType" expression="" initialRange="0" />
      <Variable name="parameterName" expression="" initialRange="0" />
    </Variables>
    <CustomProperties />
  </Template>
  <Template uid="c97980f2-9949-4584-a2ff-1948d597d934" text="var $param$ = $cmd$.CreateParameter();&#xD;&#xA;$param$.ParameterName = &quot;@$ParameterName$&quot;;&#xD;&#xA;$param$.DbType = DbType.$DbType$;&#xD;&#xA;$param$.Value = $Value$;&#xD;&#xA;$cmd$.Parameters.Add($param$);&#xD;&#xA;$END$" shortcut="p" description="Creates a parameter" reformat="true" shortenQualifiedReferences="true">
    <Categories />
    <Variables>
      <Variable name="param" expression="" initialRange="0" />
      <Variable name="cmd" expression="" initialRange="0" />
      <Variable name="ParameterName" expression="" initialRange="0" />
      <Variable name="DbType" expression="" initialRange="0" />
      <Variable name="Value" expression="" initialRange="0" />
    </Variables>
    <CustomProperties />
  </Template>
  <Template uid="a019fc9f-de3b-463b-9add-54c40fd9b96a" text="var $param$ = $cmd$.CreateParameter();&#xD;&#xA;$param$.ParameterName = &quot;@$ParameterName$&quot;;&#xD;&#xA;$param$.DbType = DbType.String;&#xD;&#xA;$param$.Size = $Size$;&#xD;&#xA;$param$.Value = $Value$;&#xD;&#xA;$cmd$.Parameters.Add($param$);&#xD;&#xA;$END$" shortcut="ps" description="Creates a IDbDataParameter for a string" reformat="true" shortenQualifiedReferences="true">
    <Categories />
    <Variables>
      <Variable name="param" expression="" initialRange="0" />
      <Variable name="cmd" expression="" initialRange="0" />
      <Variable name="ParameterName" expression="" initialRange="0" />
      <Variable name="Size" expression="" initialRange="0" />
      <Variable name="Value" expression="" initialRange="0" />
    </Variables>
    <CustomProperties />
  </Template>
  <Template uid="347ad9e0-aaeb-40f2-ba98-415b0bb4a287" text="Assert.AreEqual(&quot;$CommandText$&quot;, $cmd$.CommandText);&#xD;&#xA;Assert.AreEqual(CommandType.StoredProcedure, $cmd$.CommandType);" shortcut="tcmd" description="Tests the mock Command" reformat="true" shortenQualifiedReferences="true">
    <Categories />
    <Variables>
      <Variable name="CommandText" expression="" initialRange="0" />
      <Variable name="cmd" expression="" initialRange="0" />
    </Variables>
    <CustomProperties />
  </Template>
  <Template uid="9410dc69-11cc-4353-b139-2caf3e5692b4" text="var $parameterName$ = MockRepository.GenerateMock&lt;IDbDataParameter&gt;();&#xD;&#xA;cmd.Expect(x =&gt; x.CreateParameter()).Return($parameterName$);&#xD;&#xA;$parameterName$.Expect(x =&gt; x.ParameterName).PropertyBehavior();&#xD;&#xA;$parameterName$.Expect(x =&gt; x.Direction).PropertyBehavior();&#xD;&#xA;$parameterName$.Expect(x =&gt; x.DbType).PropertyBehavior();&#xD;&#xA;$END$" shortcut="top" description="Creates a mock for an output parameter" reformat="true" shortenQualifiedReferences="true">
    <Categories />
    <Variables>
      <Variable name="parameterName" expression="" initialRange="0" />
    </Variables>
    <CustomProperties />
  </Template>
  <Template uid="43deeb6e-560e-40ec-9bbc-70e789931f96" text="var $parameterName$ = MockRepository.GenerateMock&lt;IDbDataParameter&gt;();&#xD;&#xA;cmd.Expect(x =&gt; x.CreateParameter()).Return($parameterName$);&#xD;&#xA;$parameterName$.Expect(x =&gt; x.ParameterName).PropertyBehavior();&#xD;&#xA;$parameterName$.Expect(x =&gt; x.Value).PropertyBehavior();&#xD;&#xA;$parameterName$.Expect(x =&gt; x.DbType).PropertyBehavior();&#xD;&#xA;$END$" shortcut="tp" description="Creates a mock parameter" reformat="true" shortenQualifiedReferences="true">
    <Categories />
    <Variables>
      <Variable name="parameterName" expression="" initialRange="0" />
    </Variables>
    <CustomProperties />
  </Template>
  <Template uid="bfcfdaa9-2707-4c91-93eb-a6a654ae4b08" text="var $parameterName$ = MockRepository.GenerateMock&lt;IDbDataParameter&gt;();&#xD;&#xA;cmd.Expect(x =&gt; x.CreateParameter()).Return($parameterName$);&#xD;&#xA;$parameterName$.Expect(x =&gt; x.Size).PropertyBehavior();&#xD;&#xA;$parameterName$.Expect(x =&gt; x.ParameterName).PropertyBehavior();&#xD;&#xA;$parameterName$.Expect(x =&gt; x.Value).PropertyBehavior();&#xD;&#xA;$parameterName$.Expect(x =&gt; x.DbType).PropertyBehavior();&#xD;&#xA;$END$" shortcut="tps" description="Creates a mock parameter for a string" reformat="true" shortenQualifiedReferences="true">
    <Categories />
    <Variables>
      <Variable name="parameterName" expression="" initialRange="0" />
    </Variables>
    <CustomProperties />
  </Template>
  <Template uid="9dbc865e-ab53-4785-bb9c-a818dc5bbb48" text="Assert.AreEqual(&quot;@$ParameterName$&quot;, $param$.ParameterName);&#xD;&#xA;Assert.AreEqual(DbType.$DbType$, $param$.DbType);&#xD;&#xA;Assert.AreEqual(ParameterDirection.Output, $param$.Direction);&#xD;&#xA;$END$" shortcut="ttop" description="Tests a mocked test output parameter" reformat="true" shortenQualifiedReferences="true">
    <Categories />
    <Variables>
      <Variable name="ParameterName" expression="" initialRange="0" />
      <Variable name="param" expression="" initialRange="0" />
      <Variable name="DbType" expression="" initialRange="0" />
    </Variables>
    <CustomProperties />
  </Template>
  <Template uid="270f9c52-1deb-4a10-a18c-62e12e1cdd7d" text="Assert.AreEqual(&quot;@$ParameterName$&quot;, $param$.ParameterName);&#xD;&#xA;Assert.AreEqual($item$.$Property$, $param$.Value);&#xD;&#xA;Assert.AreEqual(DbType.$DbType$, $param$.DbType);&#xD;&#xA;$END$" shortcut="ttp" description="Tests the mocked test parameter" reformat="true" shortenQualifiedReferences="true">
    <Categories />
    <Variables>
      <Variable name="ParameterName" expression="" initialRange="0" />
      <Variable name="param" expression="" initialRange="0" />
      <Variable name="item" expression="" initialRange="0" />
      <Variable name="Property" expression="" initialRange="0" />
      <Variable name="DbType" expression="" initialRange="0" />
    </Variables>
    <CustomProperties />
  </Template>
  <Template uid="9cfe0869-8370-41d1-b172-adae71d0bf72" text="Assert.AreEqual(&quot;@$ParameterName$&quot;, $param$.ParameterName);&#xD;&#xA;Assert.AreEqual($item$.$Property$, $param$.Value);&#xD;&#xA;Assert.AreEqual($Size$, $param$.Size);&#xD;&#xA;Assert.AreEqual(DbType.String, $param$.DbType);&#xD;&#xA;$END$" shortcut="ttps" description="Tests the values in the mocked test parameter" reformat="true" shortenQualifiedReferences="true">
    <Categories />
    <Variables>
      <Variable name="ParameterName" expression="" initialRange="0" />
      <Variable name="param" expression="" initialRange="0" />
      <Variable name="item" expression="" initialRange="0" />
      <Variable name="Property" expression="" initialRange="0" />
      <Variable name="Size" expression="" initialRange="0" />
    </Variables>
    <CustomProperties />
  </Template>
</TemplatesExport>